You are here: Main Menu > I. Interface Menu > 7. External System > 6. ESI Inventory

ESI Inventory

The ESI Inventory function is used to export the current on-hand inventory balances as of the current date.

1. Follow the common External System Interface (ESI) overview and instructions found in the ESI menu overview.

2. When you first enter ESI Inventory the current system date will display; command options will also appear:

Create Inventory ESI(X) – Select Create Inventory ESI(X) to create an ESI inventory file for the current system date.
Exit – Select Exit to exit and return to the Interface menu.

Select Create Inventory ESI(X).

If the file name and type selected already exist, the following message will display: "Warning: File already exists!!! Continue? No/Yes."

Select no to return to the command options.
Select yes to create a new file with the same name that already exists.

3. The following message will display: "Create a delimited ASC file? No/Yes?"

Select no to create a DBF file only. Command options will appear allowing you to print or choose from a set of other print options.
Select yes to create a DBF file and an ASC file. Command options will appear allowing you to print or choose from a set of other print options.

Select the appropriate option.

Two DBF files will be created IVMMDDYY.dbf and IV_Last.dbf in the Shared \NetYield\Data\Company Name\ESI Outbox folder. The IVMMDDYY.dbf file is the ESI inventory file for the current on-hand inventory balances with MMDDYY equal to the current date. The IV_Last.dbf is a copy of the current file. If a ASC file was selected to be created, the name will be IVMMDDYY.asc in the Shared \NetYield\Data\Company Name\ESI Outbox folder.

The following information will print:

Item/Loc – The item name and location ID for lotted items
Quantity – The current on-hand quantity for the item and location
Unit Cost – The cost per unit in the invoicing unit of measure
Weight – The current weight on-hand
Unit Cost – The cost per unit and the stocking unit of measure
Weight – The total pounds for the item and location
Unit Cost – The unit cost per pound for un-invoiced shipments
Total Value – The total value of the inventory.

The following fields will be exported from the system:

Field Name	Description	Type
SALES_CAT	The sales category for the item	C 2
ITEM	The item code	C 8
ITEMNAME	The item name	C 30
MGMT_GROUP	The item class for the item	C 2
GROUP	The item subclass for the item	C 3
LOCATION	The location of the item, if lotted	C 2
LBSPEREACH	The weight, in pounds, for each unit	N 9
QTY_POUNDS	The on-hand quantity, in pounds	N 11, 4
QTY_STOCK	The on-hand quantity in the stocking unit of measure	N 11, 4
UN_STOCK	The stocking unit of measure	C 2
QTY_INVOIC	The on-hand quantity in the invoicing unit of measure	N 11, 4
UN INVOICE	The invoicing unit of measure
VALUE	The on-hand inventory value of the item.	N 9
UNINV_SHIP	The un-invoiced shipment quantity	N 11, 4
UNINV_UN	The un-invoiced unit of measure	C 2
UNINV_VAL	The value of the un-invoiced shipment	N 9.2
ITEMCORPID	The corporate ID for the item.	C 8

Security Required : Inventory - Inventory Reports